IBY |
您所在的位置：网站首页 › bank id branch id › IBY |
|
IBY_TEMP_EXT_BANK_ACCTS defines the temporary records for external bank accounts. DetailsSchema: FUSION Object owner: IBY Object type: TABLE Tablespace: INTERFACE Primary Key Name ColumnsIBY_TEMP_EXT_BANK_ACCTS_PK TEMP_EXT_BANK_ACCT_ID, FEEDER_IMPORT_BATCH_ID Columns Name Datatype Length Precision Not-null Comments TEMP_EXT_BANK_ACCT_ID NUMBER 18 Yes Oracle internal use only. Populated by Oracle. EXT_BANK_ACCOUNT_ID NUMBER 18 Bank account identifier. Use the Manage Bank Accounts task to identify valid values. PAYMENT_FLOW VARCHAR2 30 Yes Specifies funds capture or disbursement flow. Use the Manage Lookup Types task, lookup type IBY_PAYMENT_FLOW to identify valid values. COUNTRY_CODE VARCHAR2 2 Yes Country code where the bank is located. Use the two character ISO code. Example: United States is US. BRANCH_ID NUMBER 18 Identifies bank branch. Used if BANK_ID is populated. Use the Manage Bank Branches task to identify valid values. BANK_ID NUMBER 18 Identifies branch''s bank. Mandatory if Allow International Payments, FOREIGN_PAYMENT_USE_FLAG is Y. Use the Manage Bank Accounts task to identify valid values. BANK_NAME VARCHAR2 360 Bank name. Must be unique based on the country code. BANK_NUMBER VARCHAR2 30 Bank number. The combination of bank number, branch number, and country code must be unique for each bank. BANK_NAME_ALT VARCHAR2 360 Alternative bank name. Free text field. Not validated. BANK_INSTITUTION_TYPE VARCHAR2 80 Bank institution type. Valid values: BANK, CLEARINGHOUSE. BANK_ADDRESS_ID NUMBER 18 Oracle internal use only. BRANCH_NUMBER VARCHAR2 30 Branch number assigned by banking authority. For US banks, use the nine-digit transit routing number. The number must be unique for the bank. BRANCH_TYPE VARCHAR2 30 Branch type. Valid values: BANK_BRANCH, CLEARINGHOUSE_BRANCH. BRANCH_NAME VARCHAR2 360 Branch name. Free text field. Not validated. BRANCH_NAME_ALT VARCHAR2 360 Alternative branch name. Free text field. Not validated. BIC VARCHAR2 30 Bank Identifier Code (BIC) for the payee bank branch. First four letters are institution or bank code. Position four through six are country code. Positions six through eight are location code. Last three characters are optional: bank code. RFC_IDENTIFIER VARCHAR2 30 Branch Regional Finance Center. Applicable to US banks only. Use the Manage Cash Management Lookups task, lookup type RFC_IDENTIFIER to identify valid values. BANK_CODE VARCHAR2 100 Short code for the bank. Varies based upon country of bank branch. Use the Manage Cash Management Lookups task, lookup type BANK_CODE to identify valid values by country. BRANCH_ADDRESS_ID NUMBER 18 Branch location. Oracle internal use only. Foreign key to HZ_IMP_LOCATIONS_T.LOCATION_T_ID. ACCOUNT_OWNER_PARTY_ID NUMBER 18 Oracle internal use only. Owner party Identifier. OWNER_PRIMARY_FLAG VARCHAR2 1 Primary flag for the owner. Use: Y. Valid values: Y, N. BANK_ACCOUNT_NAME VARCHAR2 80 Bank account name. Free text field. Not validated. BANK_ACCOUNT_NUM VARCHAR2 100 Account number. The combination of bank account number, branch number, country code, and currency must be unique for each bank. CURRENCY_CODE VARCHAR2 15 Currency code. Use the Manage Currencies task to find valid values. Use the three character ISO currency code. Example: US Dollars is USD. Leave this field blank if the bank account accepts payments in multiple currencies. IBAN VARCHAR2 50 International Bank Account Number (IBAN) for the payee bank account. First two positions are letters. Third and fourth positions are numbers. Mod 97 rule is used for IBAN check digit. CHECK_DIGITS VARCHAR2 30 Check digits to validate bank account number. BANK_ACCOUNT_NAME_ALT VARCHAR2 320 Alternate account name. Free text field. Not validated. BANK_ACCOUNT_TYPE VARCHAR2 25 Bank account type. Valid values: SAVINGS, CHECKING, OTHER. Use the Manage Standard Lookups task, lookup IBY_BANKACCT_TYPES to identify valid values. ACCOUNT_SUFFIX VARCHAR2 30 Account suffix. New Zealand banks only: combination of bank account number, currency, and account suffix must be unique within a bank. DESCRIPTION VARCHAR2 240 Description. Free text field. Not validated. AGENCY_LOCATION_CODE VARCHAR2 30 Agency location code assigned by the treasury financial management service of the company. Free text field. Not validated. PAYMENT_FACTOR_FLAG VARCHAR2 1 Indicates whether this is a payment factor bank account. Valid values: Y, N. FOREIGN_PAYMENT_USE_FLAG VARCHAR2 1 Indicates whether foreign payments are permitted: when the bank branch country of payer bank account differs from payee bank account country. Valid values: Y, N. EXCHANGE_RATE_AGREEMENT_NUM VARCHAR2 80 Exchange rate agreement number. Free text field. Not validated. EXCHANGE_RATE_AGREEMENT_TYPE VARCHAR2 80 Exchange rate agreement type. Use the Manage Standard Lookups task, lookup type IBY_XCHG_RATE_AGREEMENT to identify valid values. EXCHANGE_RATE NUMBER Exchange rate per agreement between supplier and its bank account. Used to convert payment currency to bank account currency. HEDGING_CONTRACT_REFERENCE VARCHAR2 20 Hedging contract reference. Free text field. Not validated. SECONDARY_ACCOUNT_REFERENCE VARCHAR2 30 Additional account number reference. Example: Building Society Roll Number. Free text field. Not validated. START_DATE DATE Date when the bank account becomes active. Date format: YYYY/MM/DD. Must be earlier than END_DATE. END_DATE DATE Date when the bank account becomes inactive. Date format: YYYY/MM/DD. Must be later than START_DATE. ATTRIBUTE_CATEGORY VARCHAR2 150 Context code for External Bank Accounts descriptive flexfield. Use the Manage Payment System Connectivity Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for the segment values. NOTE VARCHAR2 240 Note. Free text field. NOTE_ALT VARCHAR2 240 Alternative note. Free text field. Not validated. ATTRIBUTE1 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE2 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE3 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE4 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE5 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE6 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE7 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE8 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE9 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE10 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE11 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE12 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE13 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE14 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. ATTRIBUTE15 VARCHAR2 150 Segment value for External Bank Accounts descriptive flexfield. STATUS VARCHAR2 30 Yes Status of the bank account approval process. LAST_UPDATE_DATE TIMESTAMP Yes Who column: date and time of the last update of the row. LAST_UPDATED_BY VARCHAR2 64 Yes Who column: user who last updated the row. CREATION_DATE TIMESTAMP Yes Who column: date and time of the creation of the row. CREATED_BY VARCHAR2 64 Yes Who column: user who created the row. LAST_UPDATE_LOGIN VARCHAR2 32 Who column: session login associated to the user who last updated the row. REQUEST_ID NUMBER 18 Enterprise Service Scheduler: request ID of the job that created or last updated the row. PROGRAM_APPLICATION_ID NUMBER 18 Oracle internal use only. Who column. PROGRAM_ID NUMBER 18 Oracle internal use only. Who column. PROGRAM_UPDATE_DATE DATE Oracle internal use only. Who column. OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. CALLING_APP_UNIQUE_REF1 VARCHAR2 100 Oracle internal use only. First unique identifier of the owner in the source product. CALLING_APP_UNIQUE_REF2 VARCHAR2 100 Oracle internal use only. Second unique identifier of the owner in the source product EXT_PAYEE_ID NUMBER 18 Oracle internal use only. Payee to whom the bank account must be assigned. Not used for Oracle Cloud implementations. FEEDER_IMPORT_BATCH_ID NUMBER 18 Yes Batch identifier. Must be unique. ORIG_SYSTEM VARCHAR2 80 Original system for the bank account. Not used for Oracle Cloud implementations. Free text field. Not validated. ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the bank account. Not used for Oracle Cloud implementations. Free text field. Not validated. BANK_MRG_TGT_OSR VARCHAR2 240 Oracle internal use only. Stores the original source reference of the bank merge target interface record. BRANCH_MRG_TGT_OSR VARCHAR2 240 Stores the original source reference of the branch merge target interface record. LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: request ID of the loader job that created or last updated the row. TEMP_EXT_PARTY_ID NUMBER 18 Account owner party identifier. Use either ACCOUNT_OWNER_PARTY_ID or TEMP_EXT_PARTY_ID, but not both. BANK_ACCOUNT_NUM_ELECTRONIC VARCHAR2 100 The bank account number used in electronic files, if different from the written form. BA_NUM_ELEC_SEC_SEGMENT_ID NUMBER 18 Electronically-formatted bank number security segment identifier. SALT_VERSION NUMBER 2 Denotes the versions of the encryption algorithm used for the bank account number encryption. ENTERPRISE_ID NUMBER 18 Enterprise identifier to support multi-tenancy. ENCRYPTED_FLAG VARCHAR2 1 Yes Whether the instrument is encrypted. IBAN_SEC_SEGMENT_ID NUMBER 18 Security identifier of IBAN(International Bank Account Number). IBAN_HASH1 VARCHAR2 64 Hash value of IBAN(International Bank Account Number). IBAN_HASH2 VARCHAR2 64 Salted hash value of IBAN(International Bank Account Number). MASKED_IBAN VARCHAR2 50 Masked IBAN value to be used for display purposes. BANK_ACCOUNT_NUM_HASH1 VARCHAR2 64 Hash of the bank account number. BANK_ACCOUNT_NUM_HASH2 VARCHAR2 64 Hash of the salted bank account number. MASKED_BANK_ACCOUNT_NUM VARCHAR2 100 Masked bank account number to be used for display purposes. BA_MASK_SETTING VARCHAR2 30 Current bank account masking setting values taken from lookup IBY_INSTRUMENT_MASK_SETTING. BA_UNMASK_LENGTH NUMBER 2 Number of digits to expose in the external bank account mask. BA_NUM_SEC_SEGMENT_ID NUMBER 18 Bank account number security identifier. Foreign Keys Table Foreign Table Foreign Key Column IBY_TEMP_EXT_BANK_ACCTS iby_ext_bank_accounts EXT_BANK_ACCOUNT_ID IBY_TEMP_EXT_BANK_ACCTS hz_parties BRANCH_ID IBY_TEMP_EXT_BANK_ACCTS hz_parties BANK_ID IBY_TEMP_EXT_BANK_ACCTS hz_parties ACCOUNT_OWNER_PARTY_ID IBY_TEMP_EXT_BANK_ACCTS iby_external_payees_all EXT_PAYEE_ID Indexes Index Uniqueness Tablespace Columns IBY_TEMP_EXT_BANK_ACCTS_N1 Non Unique Default EXT_BANK_ACCOUNT_ID IBY_TEMP_EXT_BANK_ACCTS_N2 Non Unique Default ACCOUNT_OWNER_PARTY_ID IBY_TEMP_EXT_BANK_ACCTS_N3 Non Unique Default BANK_ID, BRANCH_ID IBY_TEMP_EXT_BANK_ACCTS_U1 Unique Default TEMP_EXT_BANK_ACCT_ID, FEEDER_IMPORT_BATCH_ID |
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
| CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |